package com.woniuxy.common.mapper;

import com.woniuxy.common.entity.MarketLeavemessage;
import com.woniuxy.common.entity.MarketLeavemessageExample;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface MarketLeavemessageMapper {
    long countByExample(MarketLeavemessageExample example);

    int deleteByExample(MarketLeavemessageExample example);

    int deleteByPrimaryKey(String id);

    int insert(MarketLeavemessage record);

    int insertSelective(MarketLeavemessage record);

    List<MarketLeavemessage> selectByExample(MarketLeavemessageExample example);

    MarketLeavemessage selectByPrimaryKey(String id);

    int updateByExampleSelective(@Param("record") MarketLeavemessage record, @Param("example") MarketLeavemessageExample example);

    int updateByExample(@Param("record") MarketLeavemessage record, @Param("example") MarketLeavemessageExample example);

    int updateByPrimaryKeySelective(MarketLeavemessage record);

    int updateByPrimaryKey(MarketLeavemessage record);

    @Select("select * from market_leavemessage where commodity_id=#{commodityid} order by date ASC ")
    List<MarketLeavemessage> selectAllLeaveMessageByCommodityId(String commodityid);
}